package com.study.dao;

import com.study.dto.AwardDto;
import com.study.dto.MedalDto;
import com.study.dto.MedalSearchDto;
import com.study.pojo.AwardInfo;

import java.sql.SQLException;
import java.util.List;

/**
 * @PackgeName: com.study.dao.impl
 * @ClassName: AwardInfoDAO
 * @Author: 严志祥
 * Date: 2022-05-04 16:09
 * project name: web_project_medal
 * @Version:
 * @Description:
 */
public interface AwardInfoDAO extends SupperDAO<AwardInfo>{
    List<AwardDto> selectMap(int index, int len) throws SQLException;

    List<AwardDto> selectSearch(MedalSearchDto medalSearchDto) throws SQLException;

    long countSearch(MedalSearchDto medalSearchDto) throws SQLException;

    List<MedalDto> selectAward1(String countryCode) throws SQLException;
    List<MedalDto> selectAward2(String countryCode) throws SQLException;
    List<MedalDto> selectAward3(String countryCode) throws SQLException;

    List<MedalDto> selectSporting(String sportingName) throws SQLException;
}
